Load Biweekly Payroll data

Make sure you create and save the import file to a directory accessible by the Axiom Application server. The file should be saved as LD_MMDDYY_PP. For example, LD_100418_1

1. In the Admin ribbon tab, click Imports & Data Utilities > Table Current Periods.

   

2. Filter using the Table Type, and select Payroll.

   

3. Change the period for all of the payroll tables where the Uses System checkbox is not selected.

   

4. In the Table Current Periods dialog, double-click the current period for the table, and enter the new period.

   

5. When you have finished all the tables, click OK.

6. In the Admin ribbon tab, click Imports & Data Utilities > Imports > Management Reporting > 03-Load Biweekly Payroll > Execute.

7. In the Execute Import: 03-Load Biweekly Payroll dialog, click Execute.

   

8. In the Variables dialog, do the following, and click OK:

   Field	Steps
   Year Selection: Input Year (YYYY)	Enter the year to load.
   PayPeriod: Input Period (1 – 27)	In the dropdown, select the pay period to load to.

9. In the Choose the import source file dialog, navigate to the location where you stored the source file and select it.

   

10. If there are any import exceptions, follow the import exceptions remediation from Resolve import validation errors.